home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Network Support Library
/
RoseWare - Network Support Library.iso
/
btrieve
/
xql201.exe
/
XQLMPAT.201
< prev
next >
Wrap
Text File
|
1991-05-17
|
5KB
|
164 lines
; BEGIN - PATCHES FOR XQLM.EXE version 2.01
;
; * ============================================================= *
;
; Verify that original copy is being used
;
v 47e1 eb 05 c7 46 08 27 02 8b 46 08
;
; Patch #1 11/22/88
;
; If a field name in a CREATE TABLE statement is an SQL keyword, XQLM
; creates the file with an incorrect record length. This patch will
; allow XQLM to return error 536 if a specified field name is an SQL keyword.
;
r 47ab b8 19 02 eb 36 90 90
r 47b8 b8 29 02 eb 29 90 90
r 47e1 eb 03 b8 27 02 89 46 08 90 90
r 480e 74 f7 b8 18 02 eb d1
;
; end of patch #1
;
; * ============================================================= *
;
; Patch #2
;
; Executing correlated subqueries may result in status 206 from XQLP.
;
r aab4 8c c8 2d 2b 09 50 b8 46 02 50 cb
r 1a46 8b 36 16 18 8b 44 02 3c ff 74 05 bb a1 00 eb 0e
r 1a56 55 83 ec 04 89 e5 c7 46 02 01 00 bb 0f 00 8c c8
r 1a66 05 2b 09 50 31 c0 53 cb
;
; end of patch #2
;
; * ============================================================= *
;
; Patch #3 01/04/89
;
; A query using the NOT IN clause with a subquery does not return data
; when expected.
;
r d42f ff 76 23
;
; end of patch #3
;
; * ============================================================= *
;
; Patch #4 01/05/89
;
; This patch allows field list of SELECT statement to contain
; a constant integer value.
;
r af75 7E
;
; end of patch #4
;
; * ============================================================= *
;
; 05/10/89 patch #6
;
r e704 8b 46 2c a3 16 18 8b 46 22 0b 46 20 74 5d ff 36
r e714 14 18 83 7e 1c 00 75 53 8b 3e 1c 18 83 c7 07 31
r e724 c0 57 ab ab 8b 46 30
r e748 83 c4 10 5e 59 85 c0 89 46 0c 75 08 ad 01 46 28
r e758 ad 11 46 2a 83 7e 1a 00 75 0d 85 c9 75 09 90
;
; end of patch #6
;
; * ============================================================= *
;
; 08/14/89 patch #8
;
r 196d 74 12
r 1977 e9 f4 00
r 197f 07 cb e9 f1 00 90 90
r 1a6e 06 8e c0 9c e9 05 ff ad 26 89 16 88 0c e9 08 ff
;
; end of patch #8
;
; * ============================================================= *
;
; patch #9 08/14/89
;
r 5c1e 7D
;
; end of patch #9
;
; * ============================================================= *
;
; patch #10 09/13/89
;
r 12ac5 83 be 83 00 00 75 0c e9 bd 00 90 90 90 90
;
; end of patch #10
;
; * ============================================================= *
;
; patch #11 10/13/89
;
r e50c 8b 76 04 8b 44 0c 01 46 0e eb 18 8b 46 10 89 46
r e51c 14 8d 46 14 e9 d8 01 90
r e6f8 e9 1c fe
;
; end of patch #11
;
; * ============================================================= *
;
; patch #12 10/26/89
;
r 7461 8a 04 3c 7a 74 06 fe c0 88 04 eb c5 b8 49 03 eb
r 7471 0a 90 90 90 90 90 90 90 90
r 7142 85 c0 89 86 9f 02 74 07 e9 72 01 90 90 90 90
;
; end of patch #12
;
; * ============================================================= *
;
; patch #13 11/27/89
;
r 1180d 8b 1c 46 46 eb 58 89 76 3e 89 46 44 89 5e 0c
r 1185b 8a 44 0a 3c 0c 74 06 3c 0d 74 02 eb 09 e9 8b 00
r 1186b 89 76 4a eb a3 90
r 1190f 2b 46 4a
;
; end of patch #13
;
; * ============================================================= *
;
; patch #14 *** OPTIONAL ***
;
; XQLM (OPTIONAL)
; The following patch will allow a substituted value to contain an '@'
; character. This patch is optional because it will disable error
; checking in XQLExec for unresolved variables.
;
; DELETE THE SEMI-COLON FROM THE BEGINNING OF THE FOLLOWING LINES TO
; ENABLE PATCH.
;
;r 129e9 8b 7e 7d 8b 76 79 31 c9 31 db 8a 04 3c 22 75 04
;r 129f9 81 f1 01 00 83 f9 00 75 06 3c 40 75 02 43 46 4b
;r 12a09 74 0a 84 c0 74 06 88 05 47 46 eb dc 83 fb 00 74
;r 12a19 03 e9 61 02 89 76 79 89 7e 7d
;r 12da4 b8 ff ff eb 10
;
; end of patch #14
;
; * ============================================================= *
;
; patch #15 *** OPTIONAL ***
;
; (OPTIONAL)
; XQLM does not allow a semicolon in the field names of an SQL statement.
;
; DELETE THE SEMI-COLON FROM THE BEGINNING OF THE FOLLOWING LINES TO
; ENABLE PATCH.
;
;r 10cad eb 03
;
; end of patch #15
;
; * ============================================================= *
;
; END - PATCHES FOR XQLM.EXE version 2.01